from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class LawSuit(Base):
    __tablename__ = "TYC_JR_LAW_SUIT"
    ID = Column(Integer,primary_key=True)
    CASEMONEY = Column(String(100))
    SUBMITTIME = Column(Integer)
    DOCTYPE = Column(String(1000))
    LAWSUITURL = Column(String(150))
    LAWSUITH5URL = Column(String(150))
    UUID = Column(String(50))
    TITLE = Column(String(2000))
    COURT = Column(String(100))
    JUDGETIME = Column(String(255))
    CASENO = Column(String(1000))
    CASETYPE = Column(String(50))
    CASEREASON = Column(String(500))
    CASEPERSONS = Column(Text)

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)